{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Introduction","Input","Output","MatrixCalculator","Reject","EstimatorGraphs","Equations","ExampleData"],"not_rendered":{"charts":16,"images":29,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Input","index":1,"n_rows":28,"n_cols":52,"rows_kept":28,"merged":[[3,5,3,7],[3,10,3,11],[3,13,3,14],[22,13,22,14],[23,13,23,14],[24,13,24,14],[25,13,25,14],[27,13,27,14]]}
[]
[{"$nulls":23},{"v":0.66,"d":"66%"}]
[{"$nulls":23},{"v":0.95,"d":"95%"},{"$nulls":7},306.28629380242535,{"$nulls":8},{"$f":"L2*Input!$E$5/Input!$E$7","v":0},{"$nulls":9},359,3.9653867625361935E-3]
["Input:  Well ID","X (Easting)","Y (Northing)","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)                  ",{"$nulls":9},{"v":0.99,"d":"99%"}]
[{"$nulls":4},107,null,{"$f":"Output!O1","v":"Gradient"},{"$f":"Output!P1","v":"Direction"},0.01,{"v":0.66,"d":"66%"},0.2,8,{"v":1000000000,"d":"1.00E+09"}]
[{"$nulls":4},"n",{"$f":"Output!N2","v":0},{"$f":"Output!O2","v":{"v":0,"d":"0.0000"}},{"$f":"Output!P2","v":{"v":0,"d":"0.0000"}},"<--measured counterclockwise from x axis",{"$nulls":4},"m^3/d/m","kg/m/yr"]
[{"$nulls":4},0.35,{"$f":"Output!N3","v":0},{"$f":"Output!O3","v":{"v":0,"d":"0.0000"}},{"$f":"Output!P3","v":{"v":0,"d":"0.0000"}}]
[{"$nulls":4},"Speed (L/T)"]
[{"$nulls":4},{"$f":"E5*G9*1/E7","v":{"v":0,"d":"0.0000"}},{"$f":"Output!N5","v":0},{"$f":"Output!O5","v":{"v":0,"d":"0.0000"}},{"$f":"Output!P5","v":{"v":0,"d":"0.0000"}}]
{"$rows_empty":13}
[{"$nulls":13},"Vector view"]
[{"$nulls":13},"Time of travel (T)"]
[{"$nulls":13},5]
[{"$nulls":13},"Rotate Direction"]
[{"$nulls":13},"Direction (o)","c-clockwise"]
[{"$nulls":13},0]

{"sheet":"Output","index":2,"n_rows":14,"n_cols":52,"rows_kept":14}
["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",{"$nulls":5},"Rotated Direction \n(o)  --->",{"$f":"Input!N28","v":0},"Direction Bin Range",{"$nulls":6},"Velocity\n(m/d)",null,null,"Velocity Bin Range",{"$nulls":6},"Estimator Area","gradient"]
[{"$nulls":24},"max",{"$f":"MAX(L2:L1000)","v":0},{"$nulls":6},"max",{"$f":"IF(MAX(AF2:AF1000)+45<360, MAX(AF2:AF1000)+45,MAX(AF2:AF1000))","v":45},{"$nulls":8},"max",{"$f":"MAX(AO2:AO1000)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":24},"min",{"$f":"MIN(L2:L1000)","v":0},{"$nulls":6},"min",{"$f":"IF(MIN(AF2:AF1000)-45<0,MIN(AF2:AF1000),MIN(AF2:AF1000)-45)","v":0},{"$nulls":8},"min",{"$f":"MIN(AO2:AO1000)","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":25},{"$f":"$Z$2","v":0},{"$nulls":7},{"$f":"$AH$2","v":45},{"$f":"AK15","v":0},{"$nulls":8},{"$f":"AR2","v":{"v":0,"d":"0.00"}}]
[{"$nulls":25},{"$f":"Z5-($Z$2-$Z$3)/9","v":0},{"$nulls":7},{"$f":"AH5-($AH$2-$AH$3)/9","v":40},{"$f":"AK14","v":0},{"$nulls":8},{"$f":"AR5-($AR$2-$AR$3)/9","v":{"v":0,"d":"0.00"}}]
[{"$nulls":25},{"$f":"Z6-($Z$2-$Z$3)/9","v":0},{"$nulls":7},{"$f":"AH6-($AH$2-$AH$3)/9","v":35},{"$f":"AK13","v":0},{"$nulls":8},{"$f":"AR6-($AR$2-$AR$3)/9","v":{"v":0,"d":"0.00"}}]
[{"$nulls":25},0,{"$nulls":7},30,{"$f":"AK12","v":0},{"$nulls":8},{"v":0,"d":"0.00"}]
[{"$nulls":25},0,{"$nulls":7},25,{"$f":"AK11","v":0},{"$nulls":8},{"v":0,"d":"0.00"}]
[{"$nulls":25},0,{"$nulls":7},20,{"$f":"AK10","v":0},{"$nulls":8},{"v":0,"d":"0.00"}]
[{"$nulls":25},0,{"$nulls":7},15,{"$f":"AK9","v":0},{"$nulls":8},{"v":0,"d":"0.00"}]
[{"$nulls":25},0,{"$nulls":7},10,{"$f":"AK8","v":0},{"$nulls":8},{"v":0,"d":"0.00"}]
[{"$nulls":25},0,{"$nulls":7},5,{"$f":"AK7","v":0},{"$nulls":8},{"v":0,"d":"0.00"}]
[{"$nulls":25},0,{"$nulls":7},0,{"$f":"AK6","v":0},{"$nulls":8},{"v":0,"d":"0.00"}]

{"sheet":"MatrixCalculator","index":3,"n_rows":53,"n_cols":41,"rows_kept":53,"merged":[[0,1,0,4],[0,6,0,7],[0,9,0,11],[3,1,3,4],[4,0,4,4]]}
[{"$nulls":5}," "," ",null," "," ",null,null," "]
[{"$nulls":6},"gradient","angle on x",null,"A","B","C",{"$nulls":28},{"$f":"-L2*Input!$E$5/Input!$E$7","v":{"$error":"#VALUE!"}}]
[{"$nulls":6},{"$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!"}}]
[{"$nulls":7},{"$f":"IF(M9>N9,H3,H3+180)","v":{"$error":"#NUM!"}},{"$nulls":4},"x","y","H"]
["Data Points Input",{"$nulls":11},0,0,{"$f":"(J3*M5+K3*N5-1)/L3","v":{"$error":"#NUM!"}}]
["#","x","y","z","D","calc z",{"$nulls":6},"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!"}},{"$nulls":6},"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!"}},{"$nulls":6},{"v":-1000000,"d":"-1.00E+06"},{"v":1000000,"d":"1.00E+06"},{"v":1000000,"d":"1.00E+06"},-1000000]
[null,0,0,0,1,{"$error":"#NUM!"},null,1,{"$nulls":4},{"$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!"},{"$nulls":6},"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!"}]
[]
[]
[]
[{"$nulls":5},"Pt"]
[{"$nulls":5},{"$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]
[{"$nulls":5},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[{"$nulls":5},"{[P]t[P]}"]
[{"$nulls":5},{"$f":"MMULT(F31:Y33,B7:D26)","v":0},0,0]
[{"$nulls":5},0,0,0]
[{"$nulls":5},0,0,0]
[]
[{"$nulls":5},"{[P]t[P]}'"]
[{"$nulls":5},{"$f":"MINVERSE(F36:H38)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[{"$nulls":5},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[{"$nulls":5},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[]
[{"$nulls":5},"{[P]t[P]}'[P]t"]
[{"$nulls":5},{"$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!"}]
[{"$nulls":5},{"$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!"}]
[{"$nulls":5},{"$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!"}]
[]
[{"$nulls":5},"{[P]t[P]}'[P]t [D]"]
[{"$nulls":5},{"$f":"MMULT(F46:Y48,E7:E26)","v":{"$error":"#NUM!"}},"A"]
[{"$nulls":5},{"$error":"#NUM!"},"B"]
[{"$nulls":5},{"$error":"#NUM!"},"C"]

{"sheet":"Reject","index":4,"n_rows":1,"n_cols":12,"rows_kept":1}
["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}
[null,"well","well","well","well",{"$nulls":6},"max grad",0.02525524081617099,"Vector \nMag. factor",{"$f":"Input!E5/Input!E7","v":305.7142857142857},"K (L/T)",{"$f":"Input!E5","v":107},"n",{"$f":"Input!E7","v":0.35},{"$nulls":12},"Replotting Estimators","Well 1","Well 2","Well 3",null,"Row Source"]
[null,"A","B","C","A","gradient","angle"," centroid","x'_ y'","Vel (L/T)",{"$nulls":3},"days",{"$f":"Input!N25","v":5}]
[{"$nulls":36},{"$f":"IF(ISBLANK(Input!A5), \"\",Input!A5)","v":""}]
[{"$nulls":36},{"$f":"IF(ISBLANK(Input!A6), \"\",Input!A6)","v":""}]
[{"$nulls":36},{"$f":"IF(ISBLANK(Input!A7), \"\",Input!A7)","v":""}]
[{"$nulls":36},{"$f":"IF(ISBLANK(Input!A8), \"\",Input!A8)","v":""}]
[{"$nulls":36},{"$f":"IF(ISBLANK(Input!A9), \"\",Input!A9)","v":""}]
[{"$nulls":36},{"$f":"IF(ISBLANK(Input!A10), \"\",Input!A10)","v":""}]
[{"$nulls":36},{"$f":"IF(ISBLANK(Input!A11), \"\",Input!A11)","v":""}]
[{"$nulls":36},{"$f":"IF(ISBLANK(Input!A12), \"\",Input!A12)","v":""}]
[{"$nulls":25},{"$f":"360-17","v":343},{"$nulls":10},{"$f":"IF(ISBLANK(Input!A13), \"\",Input!A13)","v":""}]
[{"$nulls":36},{"$f":"IF(ISBLANK(Input!A14), \"\",Input!A14)","v":""}]
[{"$nulls":36},{"$f":"IF(ISBLANK(Input!A15), \"\",Input!A15)","v":""}]
[{"$nulls":36},{"$f":"IF(ISBLANK(Input!A16), \"\",Input!A16)","v":""}]
[{"$nulls":36},{"$f":"IF(ISBLANK(Input!A17), \"\",Input!A17)","v":""}]
[{"$nulls":36},{"$f":"IF(ISBLANK(Input!A18), \"\",Input!A18)","v":""}]
[{"$nulls":36},{"$f":"IF(ISBLANK(Input!A19), \"\",Input!A19)","v":""}]
[{"$nulls":36},{"$f":"IF(ISBLANK(Input!A20), \"\",Input!A20)","v":""}]
[{"$nulls":36},{"$f":"IF(ISBLANK(Input!A21), \"\",Input!A21)","v":""}]
[{"$nulls":36},{"$f":"IF(ISBLANK(Input!A22), \"\",Input!A22)","v":""}]
[{"$nulls":36},{"$f":"IF(ISBLANK(Input!A23), \"\",Input!A23)","v":""}]
[{"$nulls":36},{"$f":"IF(ISBLANK(Input!A24), \"\",Input!A24)","v":""}]

{"sheet":"Equations","index":6,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"ExampleData","index":7,"n_rows":43,"n_cols":4,"rows_kept":43}
["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.479]
["MW-7S",425,-65,888.64]
["MW-3S",420,7,888.4795]
["MW-5S",670,0,887.72]
[]
[]
["Data from Schillig et al, 2015"]
["Well ID","x","y","water elevation"]
["WO35",94.03707999998005,76.32147999946028,297.837]
["WO74",170.15214999997988,40.30500999931246,297.66200000000003]
["WO77",161.6700000000419,52.286999999545515,297.704]
["WO78",158.2399999999907,48.6269999993965,297.697]
["WO79",154.8400000000256,44.93699999898672,297.696]
["WO80",151.40000000002328,41.08699999935925,297.69899999999996]
["WO64",0,77.39699999894947,297.978]
["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.44]
["W15",72,64,4.29]
["W6",34,58,4.36]
["W9",53,48,4.26]
["W10",55.5,42.5,4.26]
["W4",24,40,4.14]
["W17",78,27.5,4.07]
["W18",75,17,4.12]
["W8",56,2.5,4.03]
["W7",37.5,0,4.01]