{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":1,"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":73,"n_cols":10,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
["Example 4-5.  Bedient P 257"]
[]
["Dt",10,"min"]
[null,{"$f":"B3*60","v":600},"sec"]
["h","S","2*S/Dt+Q","Q"]
["(ft)","(ft^3)","cfs","cfs"]
[0,0,{"$f":"2*B7/$B$4+D7","v":0},0]
[1,6772,35.573333333333338,13]
[2,15161,68.536666666666662,18]
[3,25310,106.36666666666666,22]
[4,37361,150.53666666666666,26]
[5,51457,200.52333333333334,29]
[5.5,59173,247.24333333333334,50]
[6,67167,310.89,87]
[6.5,75443,387.47666666666669,136]
[7,84006,473.02,193]
[]
["Row considered at time n+1"]
["Time","Inflow","I(n)+I(n+1)","2S/Dt-Q","2S/Dt+Q","Q","S"]
["min","cfs","cfs"]
[0,0,0,0,0,0,0]
[10,20,{"$f":"B21+B22","v":20},{"$f":"2*G21/$B$4-F21","v":0},{"$f":"D22+C22","v":20},{"$f":"Linterp($C$7:$D$16,E22)","v":7.3088455772113932},{"$f":"(E22-F22)*$B$4/2","v":3807.3463268365822}]
[20,40]
[30,60]
[40,50]
[50,40]
[60,30]
[70,20]
[80,10]
[90,0]
[100,0]
[110,0]
[120,0]
[130,0]
[140,0]
[150,0]
[160,0]
[]
[]
["Runga-Kutta"]
["h","A","h","Q",null,"S"]
["(ft)","ft^2","(ft)","cfs",null,"(ft^3)"]
[0,6000,0,0,null,0]
[1,7545,1,13,null,6772]
[2,9233,2,18,null,15161]
[3,11064,3,22,null,25310]
[4,13038,4,26,null,37361]
[5,15155,5,29,null,51457]
[5.5,15707,5.5,50,null,59173]
[6,16268,6,87,null,67167]
[6.5,16873,6.5,136,null,75443]
[7,17416,7,193,null,84006]
[]
["Row considered at time n+1"]
["Time","Inflow","f(H_n,t_n)","DH1","f(H+DH1)","DH2","DH","H","Q","A"]
["min","cfs",null,null,null,null,null,"ft","cfs","ft^2"]
[0,0,null,null,null,null,null,0,{"$f":"Linterp($C$43:$D$52,H57)","v":0},{"$f":"Linterp($A$43:$B$52,H57)","v":6000}]
[10,20,{"$f":"(B57-I57)/J57","v":0},{"$f":"C58*$B$4","v":0},{"$f":"(B58-Linterp($C$43:$D$52,H57+D58))/Linterp($A$43:$B$52,H57+D58)","v":3.3333333333333335E-3},{"$f":"E58*$B$4","v":2},{"$f":"(D58+F58)/2","v":1},{"$f":"H57+G58","v":1},{"$f":"Linterp($C$43:$D$52,H58)","v":13},{"$f":"Linterp($A$43:$B$52,H58)","v":7545}]
[20,40]
[30,60]
[40,50]
[50,40]
[60,30]
[70,20]
[80,10]
[90,0]
[100,0]
[110,0]
[120,0]
[130,0]
[140,0]
[150,0]
[160,0]

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

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