{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Introduction","Input","Output","MatrixCalculator","Reject","EstimatorGraphs","Equations","ExampleData"],"not_rendered":{"charts":16,"images":29,"macros":1,"external_links":0,"defined_names":0,"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":"Introduction","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Input","index":1,"n_rows":28,"n_cols":52,"rows_kept":28,"cut":false,"hidden":false,"merged":[[3,5,3,7],[27,13,27,14],[25,13,25,14],[22,13,22,14],[23,13,23,14],[24,13,24,14],[3,10,3,11],[3,13,3,14]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.66]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.95,null,null,null,null,null,null,null,306.28629380242535,null,null,null,null,null,null,null,null,{"$f":"L2*Input!$E$5/Input!$E$7","v":0},null,null,null,null,null,null,null,null,null,359,3.9653867625361935E-3]
["Input:  Well ID","X (Easting) \nno two identical","Y (Northing) \nno two identical","Z (Hydraulic Head)","K (L/T)","Summary of Output",null,null,"+/- on Head (L)","Confidence Level","Base:Height constraint\nLow           High",null,"max  base or height (L)","Total Discharges\nQ (L3/(LT)     Jtot(M/LT)                  ",null,null,null,null,null,null,null,null,null,0.99]
[null,null,null,null,2500,null,{"$f":"Output!O1","v":"Gradient"},{"$f":"Output!P1","v":"Direction"},0.01,0.66,0.2,8,1000000000]
[null,null,null,null,"n",{"$f":"Output!N2","v":0},{"$f":"Output!O2","v":0},{"$f":"Output!P2","v":0},"<--measured counterclockwise from x axis",null,null,null,null,"ft^3/d/ft","kg/m/yr"]
[null,null,null,null,0.3,{"$f":"Output!N3","v":0},{"$f":"Output!O3","v":0},{"$f":"Output!P3","v":0}]
[null,null,null,null,"Speed (L/T)"]
[null,null,null,null,{"$f":"E5*G9*1/E7","v":0},{"$f":"Output!N5","v":0},{"$f":"Output!O5","v":0},{"$f":"Output!P5","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Vector view"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Time of travel (T)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Rotate Direction"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Direction (o)","c-clockwise"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Output","index":2,"n_rows":14,"n_cols":52,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Input:  Well ID","X\n(Easting)\n(L)","Y \n(Northing) \n(L)","Z \n(Hydraulic Head) \n(L)","+/- \non Head (L)","Adjusted X-Coordinate","Adjusted Y-Coordinate",null,"Well A","Well B","Well C","Gradient","Flow Direction from X Direction",null,"Gradient","Direction","AB/BC","AC/BC","AC/AB","AB/H1","BC/H2","AC/H3","Max DWL (L)",null,null,"Gradient Bin Range",null,null,null,null,null,"Rotated Direction \n(o)  --->",{"$f":"Input!N28","v":0},"Direction Bin Range",null,null,null,null,null,null,"Velocity\n(m/d)",null,null,"Velocity Bin Range",null,null,null,null,null,null,"Estimator Area","gradient"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"max",{"$f":"MAX(L2:L1000)","v":0},null,null,null,null,null,null,"max",{"$f":"IF(MAX(AF2:AF1000)+45<360, MAX(AF2:AF1000)+45,MAX(AF2:AF1000))","v":45},null,null,null,null,null,null,null,null,"max",{"$f":"MAX(AO2:AO1000)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"min",{"$f":"MIN(L2:L1000)","v":0},null,null,null,null,null,null,"min",{"$f":"IF(MIN(AF2:AF1000)-45<0,MIN(AF2:AF1000),MIN(AF2:AF1000)-45)","v":0},null,null,null,null,null,null,null,null,"min",{"$f":"MIN(AO2:AO1000)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$Z$2","v":0},null,null,null,null,null,null,null,{"$f":"$AH$2","v":45},{"$f":"AK15","v":0},null,null,null,null,null,null,null,null,{"$f":"AR2","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Z5-($Z$2-$Z$3)/9","v":0},null,null,null,null,null,null,null,{"$f":"AH5-($AH$2-$AH$3)/9","v":40},{"$f":"AK14","v":0},null,null,null,null,null,null,null,null,{"$f":"AR5-($AR$2-$AR$3)/9","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Z6-($Z$2-$Z$3)/9","v":0},null,null,null,null,null,null,null,{"$f":"AH6-($AH$2-$AH$3)/9","v":35},{"$f":"AK13","v":0},null,null,null,null,null,null,null,null,{"$f":"AR6-($AR$2-$AR$3)/9","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,30,{"$f":"AK12","v":0},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,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,25,{"$f":"AK11","v":0},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,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,20,{"$f":"AK10","v":0},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,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,15,{"$f":"AK9","v":0},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,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,10,{"$f":"AK8","v":0},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,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,5,{"$f":"AK7","v":0},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,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,{"$f":"AK6","v":0},null,null,null,null,null,null,null,null,0]

{"sheet":"MatrixCalculator","index":3,"n_rows":53,"n_cols":41,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,9,0,11],[4,0,4,4],[3,1,3,4],[0,6,0,7],[0,1,0,4]]}
[null,null,null,null,null," "," ",null," "," ",null,null," "]
[null,null,null,null,null,null,"gradient","angle on x",null,"A","B","C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-L2*Input!$E$5/Input!$E$7","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,{"$f":"((F51^2+F52^2)/F53^2)^0.5","v":{"$error":"#NUM!"}},{"$f":"ATAN(F52/F51)*180/PI()","v":{"$error":"#NUM!"}},null,{"$f":"F51","v":{"$error":"#NUM!"}},{"$f":"F52","v":{"$error":"#NUM!"}},{"$f":"-F53","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,{"$f":"IF(M9>N9,H3,H3+180)","v":{"$error":"#NUM!"}},null,null,null,null,"x","y","H"]
["Data Points Input",null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"(J3*M5+K3*N5-1)/L3","v":{"$error":"#NUM!"}}]
["#","x","y","z","D","calc z",null,null,null,null,null,null,"Determine if plane dips to the east or west"]
[null,0,0,0,1,{"$f":"(B7*$J$3+C7*$K$3-E7)/$L$3","v":{"$error":"#NUM!"}},null,null,null,null,null,null,"west x","east x","north y","south y"]
[null,0,0,0,1,{"$f":"(B8*$J$3+C8*$K$3-E8)/$L$3","v":{"$error":"#NUM!"}},null,null,null,null,null,null,-1000000,1000000,1000000,-1000000]
[null,0,0,0,1,{"$error":"#NUM!"},null,1,null,null,null,null,{"$f":"(-1)*(1-$J$3*M8)/$L$3","v":{"$error":"#NUM!"}},{"$f":"(-1)*(1-$J$3*N8)/$L$3","v":{"$error":"#NUM!"}},{"$f":"(-1)*(1-$K$3*O8)/$L$3","v":{"$error":"#NUM!"}},{"$f":"(-1)*(1-$K$3*P8)/$L$3","v":{"$error":"#NUM!"}}]
[null,0,0,0,1,{"$error":"#NUM!"},null,null,null,null,null,null,"flow direction E-W",{"$f":"IF(N9=M9,\"ND\",IF(N9>M9,\"west\",\"east\"))","v":{"$error":"#NUM!"}},"flow direction N-S",{"$f":"IF(P9=O9,\"ND\",IF(P9>O9,\"north\",\"south\"))","v":{"$error":"#NUM!"}}]
[null,0,0,0,1,{"$error":"#NUM!"}]
[null,0,0,0,1,{"$error":"#NUM!"}]
[null,0,0,0,1,{"$error":"#NUM!"}]
[null,0,0,0,1,{"$error":"#NUM!"}]
[null,0,0,0,1,{"$error":"#NUM!"}]
[null,0,0,0,1,{"$error":"#NUM!"}]
[null,0,0,0,1,{"$error":"#NUM!"}]
[null,0,0,0,1,{"$error":"#NUM!"}]
[null,0,0,0,1,{"$error":"#NUM!"}]
[null,0,0,0,1,{"$error":"#NUM!"}]
[null,0,0,0,1,{"$error":"#NUM!"}]
[null,0,0,0,1,{"$error":"#NUM!"}]
[null,0,0,0,1,{"$error":"#NUM!"}]
[null,0,0,0,1,{"$error":"#NUM!"}]
[null,0,0,0,1,{"$error":"#NUM!"}]
[null,0,0,0,1,{"$error":"#NUM!"}]
[]
[]
[]
[null,null,null,null,null,"Pt"]
[null,null,null,null,null,{"$f":"TRANSPOSE(B7:D26)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,"{[P]t[P]}"]
[null,null,null,null,null,{"$f":"MMULT(F31:Y33,B7:D26)","v":0},0,0]
[null,null,null,null,null,0,0,0]
[null,null,null,null,null,0,0,0]
[]
[null,null,null,null,null,"{[P]t[P]}'"]
[null,null,null,null,null,{"$f":"MINVERSE(F36:H38)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[]
[null,null,null,null,null,"{[P]t[P]}'[P]t"]
[null,null,null,null,null,{"$f":"MMULT(F41:H43,F31:Y33)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[]
[null,null,null,null,null,"{[P]t[P]}'[P]t [D]"]
[null,null,null,null,null,{"$f":"MMULT(F46:Y48,E7:E26)","v":{"$error":"#NUM!"}},"A"]
[null,null,null,null,null,{"$error":"#NUM!"},"B"]
[null,null,null,null,null,{"$error":"#NUM!"},"C"]

{"sheet":"Reject","index":4,"n_rows":1,"n_cols":12,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Well A","Well B","Well C",null,"AB/BC","AC/BC","AC/AB","AB/H1","BC/H2","AC/H3","Max DWL (cm)","DWL Min."]

{"sheet":"EstimatorGraphs","index":5,"n_rows":22,"n_cols":37,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,"well","well","well","well",null,null,null,null,null,null,"max grad",4.4840142617822163E-3,"Vector \nMag. factor",{"$f":"Input!E5/Input!E7","v":8333.3333333333339},"K (L/T)",{"$f":"Input!E5","v":2500},"n",{"$f":"Input!E7","v":0.3},null,null,null,null,null,null,null,null,null,null,null,null,"Replotting Estimators","Well 1","Well 2","Well 3",null,"Row Source"]
[null,"A","B","C","A","gradient","angle"," centroid","x'_ y'","Vel (L/T)",null,null,null,"days",{"$f":"Input!N25","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Input!A5), \"\",Input!A5)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Input!A6), \"\",Input!A6)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Input!A7), \"\",Input!A7)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Input!A8), \"\",Input!A8)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Input!A9), \"\",Input!A9)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Input!A10), \"\",Input!A10)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Input!A11), \"\",Input!A11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Input!A12), \"\",Input!A12)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"360-17","v":343},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Input!A13), \"\",Input!A13)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Input!A14), \"\",Input!A14)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Input!A15), \"\",Input!A15)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Input!A16), \"\",Input!A16)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Input!A17), \"\",Input!A17)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Input!A18), \"\",Input!A18)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Input!A19), \"\",Input!A19)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Input!A20), \"\",Input!A20)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Input!A21), \"\",Input!A21)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Input!A22), \"\",Input!A22)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Input!A23), \"\",Input!A23)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Input!A24), \"\",Input!A24)","v":""}]

{"sheet":"Equations","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"ExampleData","index":7,"n_rows":43,"n_cols":4,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Data from Ferrey et al., 2000"]
["Well ID","x","y","water elevation"]
["MW-6S",0,10,890.47]
["MW-4S",75,-20,890.13]
["MW-8S",205,-160,889.48]
["MW-1S",290,220,889.47900000000004]
["MW-7S",425,-65,888.64]
["MW-3S",420,7,888.47950000000003]
["MW-5S",670,0,887.72]
[]
[]
["Data from Schillig et al, 2015"]
["Well ID","x","y","water elevation"]
["WO35",94.037079999980051,76.32147999946028,297.83699999999999]
["WO74",170.15214999997988,40.30500999931246,297.66200000000003]
["WO77",161.67000000004191,52.286999999545515,297.70400000000001]
["WO78",158.23999999999069,48.626999999396503,297.697]
["WO79",154.84000000002561,44.936999998986721,297.69600000000003]
["WO80",151.40000000002328,41.08699999935925,297.69899999999996]
["WO64",0,77.396999998949468,297.97800000000001]
["WO75S",131.36044000001857,0,297.745]
[]
[]
["Skuldeleve data"]
["Well","x","y","z"]
["W12",75,100,4.46]
["W11",60,98,4.41]
["W13",75,93,4.45]
["W5",34,93,4.55]
["W1",2,91,4.53]
["W16",79,85,4.47]
["W14",68,81,4.34]
["W2",22.5,74,4.45]
["W3",26,71,4.4400000000000004]
["W15",72,64,4.29]
["W6",34,58,4.3600000000000003]
["W9",53,48,4.26]
["W10",55.5,42.5,4.26]
["W4",24,40,4.1399999999999997]
["W17",78,27.5,4.07]
["W18",75,17,4.12]
["W8",56,2.5,4.03]
["W7",37.5,0,4.01]