{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"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":"Sheet1","index":0,"n_rows":31,"n_cols":19,"rows_kept":31,"cut":false,"hidden":false,"merged":[[10,8,10,9],[10,12,10,13],[10,0,10,1],[6,2,6,6],[7,2,7,6],[10,4,10,5],[17,0,17,1],[0,1,0,6],[5,2,5,6],[4,2,4,6],[3,2,3,6],[2,2,2,6],[1,2,1,6]]}
["Input ","Value"]
["a",1,"bed slope (degrees)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Description","Variable ","VBA Parameter"]
["p",3,"rainfall rate (in/hr)",null,null,null,null,null,null,"Choose Case",{"$f":"ChooseCase($B$12,$B$3,$B$4)","v":"Case 1"},null,null,null,null,null,"bed slope","a","a"]
["k",2,"hydraulic conductivity (in/hr)",null,null,null,null,null,null,null,null,null,null,null,null,null,"rainfall rate","p","p"]
["x",1,"horizontal distance measured from upper drain",null,null,null,null,null,null,null,null,null,null,null,null,null,"hydraulic conductivity","k","k"]
["z",{"$f":"zEstimated(K3,F21,J21,N21)","v":1.3844557132573287},"vertical distance of the water table above the sloping bed",null,null,null,null,null,null,null,null,null,null,null,null,null,"horizontal distance from upper drain","x ","x"]
["L",1,"horizontal distance between the drains",null,null,null,null,null,null,null,null,null,null,null,null,null,"vertical distance of water table above sloping bed","z","z"]
["ℒ ",0.5,"horizontal distance to the watershed",null,null,null,null,null,null,null,null,null,null,null,null,null,"horizontal distance between the drains","L","L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"horizontal distance to the watershed","ζ","curvyL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Value differentiating between case 1, 2, or 3","A","capA"]
["Defining Values",null,null,null,"Case 1 Values",null,null,null,"Case 2 Values",null,null,null,"Case 3 Values",null,null,null,"Relationship between x and ζ","v","vValue"]
["A",{"$f":"capA($B$2,$B$3,$B$4)","v":-0.5},null,null,"m",{"$f":"mValue($B$3,$B$4,$B$12)","v":0.83405765622829908},null,null,"H2",{"$f":"capH2($B$7,$B$2,$B$3,$B$4,$B$12)","v":"N/A"},null,null,"W1",{"$f":"capW1($B$12,$B$3,$B$4)","v":"N/A"},null,null,"Defining value for all cases","W","capW"]
["v",{"$f":"vValue($B$5,$B$8)","v":0.5},null,null,"u0",{"$f":"uSub0($F$12,$B$3,$B$4,$B$2,$B$12)","v":-1.0425720702853738},null,null,"X2",{"$f":"capX2($B$4,$B$3,$B$2,$J$12)","v":"N/A"},null,null,"W2",{"$f":"capW2($B$12,$B$3,$B$4)","v":"N/A"},null,null,"Defining value for case 1","m","mValue"]
["W",{"$f":"capW(B6,B13,B2,B3,B4)","v":1.2689114265146575},null,null,"uH",{"$f":"uSubH($F$12,$B$3,$B$4,$B$2,$B$12)","v":1.4596008983995234},null,null,null,null,null,null,"H3",{"$f":"capH3($B$7, $B$2,$N$13, $B$4,$B$3,$N$12)","v":"N/A"},null,null,"Defining value for case 1","u0","uSub0"]
[null,null,null,null,"H1",{"$f":"capH1($B$7,$B$8,$B$2,$B$3,$B$4,$F$13,$F$14,$B$12,$F$12)","v":2.4553102877602124},null,null,null,null,null,null,"X3",{"$f":"capX3($B$4,$B$3,$B$2,$N$14)","v":"N/A"},null,null,"Defining value for case 1","uH","uSubH"]
[null,null,null,null,"u",{"$f":"uValue($F$12,$B$14,$B$12)","v":1.2668597044171976},null,null,null,null,null,null,"C4",{"$f":"capC4(B12,N12,N13,N14,B2,B4,B3)","v":"N/A"},null,null,"Height of the mound of water for case 1","H1","capH1"]
[null,null,null,null,"X1",{"$f":"capX1($B$8,$B$4,$B$3,$B$2,$F$15)","v":1.3184367625867375},null,null,null,null,null,null,null,null,null,null,"Defining value for case 1","u","uValue"]
["Newton guessing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Horizontal distance to mound for case 1","X1","capX1"]
["Stepsize",1E-3,null,null,"Case 1A \"z\" Estimation",null,null,null,"Case 2 \"z\" Estimation",null,null,null,"Case 3 \"z\" Estimation",null,null,null,"Height of the mound of water for case 2","H2","capH2"]
["tolerance",9.9999999999999995E-7,null,null,"z Guess","z Estimated","Function Value",null,"z Guess","z Estimated","Function Value",null,"z Guess","z Estimated","Function Value",null,"Horizontal distance to mound for case 2","X2","capX2"]
["how many",300,null,null,1,{"$f":"NewtonCase1(B19,E21,B20,B21,F12,B5,B8,B3,B4,B2,B12,F15,B13,K3)","v":1.3844557132573287},{"$f":"Case1(F12,F21,B5,B8,B3,B4,B2,B12,F15,B13)","v":5.3838574709530462E-9},null,0.1,{"$f":"NewtonCase2(B19,B20,B21,B12,B2,B3,B4,B5,B7, I21,B13, K3)","v":"N/A"},{"$f":"case2(B12,B2,B3,B4,B5,B7,J21,B13)","v":"N/A"},null,1.01,{"$f":"NewtonCase3(B19,B20,B21, M21, N12,N13,B5,B2,B3,B4,N16,B12,K3)","v":"N/A"},{"$f":"Case3(N12,N13,N21,B5, B2,B3,B4,N16, B12)","v":"N/A"},null,"Defining value for case 3","W1","capW1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defining value for case 3","W2","capW2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Height of the mound of water for case 3","H3","capH3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Horizontal distance to mound for Case 3","X3","capX3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defining value for case 3","C4","capC4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Solution function for case 1",null,"Case1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manipulation of solution function to estimate z given x",null,"NewtonCase1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Solution function for case 2",null,"Case2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manipulation of solution function to estimate z given x",null,"NewtonCase2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Solution function for case 3",null,"Case3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manipulation of solution function to estimate z given x",null,"NewtonCase3"]