{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["LONGPRO"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":1,"defined_names":5,"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":"LONGPRO","index":0,"n_rows":39,"n_cols":20,"rows_kept":39,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"LONGPRO - Modelling alluvial streams"]
[null,"  This template allows rapid calculation of the effects on the long profile of a river of changes, either downstream or at a point,"]
[null,"in the input of water and bedload, of bedload caliber (sand to gravel), of channel roughness, and of channel width. "]
[null,"The mathematical model described here (from Snow, 1991) generates an equilibrium model based on long-term"]
[null,"average inputs."]
[]
[null,"  To use this template, enter appropriate values in those columns which are headed by ALL CAPITAL"]
[null,"LETTERS.  Columns headed by upper and lower case letters will be calculated by the spreadsheet. (You should also  "]
[null,"enter a width coefficient in block D18 before starting.) All values will be automatically recalculated as you proceed. "]
[null,"DO NOT erase, write over, or otherwise change the values in the upper/lower case columns."]
[]
[null," The MEASURED PROFILE is already that of Middle Cottonwood Creek - change if another stream system is modeled."]
[null,"  If you need more lines, insert rows ABOVE the bottom row, and block copy into them from above. If you need fewer rows,"]
[null,"delete them ABOVE the bottom row. (The bottom row includes the starting point for the long profile calculations.)"]
[null,"  This spreadsheet will automatically graph the long profile. To change the increment, graph other variables, label, "]
[null,"or print, use the \"Help\" function of the software."]
[null," For reference, the mouth of the bedrock canyon (head of the fan) is marked with the green line."]
[null,"REFERENCE: Snow, R.S., 1991, Jour. Geol. Ed., v. 39, p. 227-229."]
[]
[null,"WIDTH COEFFICIENT:",null,4]
[{"$nulls":6},"IN(OUT)PUT"]
[null,"Distance","DISCHARGE","Total","BEDLOAD","Sediment","BEDLOAD","Averaged","MANNING","IMPOSED","Channel","Slope","Velocity","Depth","Water Sfc.","Bed","MEASURED","Measured","Measured","SITE"]
[null,"Downstream","IN(OUT)PUT","Discharge","IN(OUT)PUT","Discharge","CALIBER","Caliber","ROUGH-","WIDTH (m)","Width",null,null,null,"Elev.","Elev.","PROFILE","Profile","minus","ID"]
[null,"  (km)"," (m^3/s)"," (m^3/s)"," (m^3/s)"," (m^3/s)","(mm)","(mm)","NESS","(optional)","(m)","(m/m)","(m/s)","(m)","(m)","(m)","(ft)","(m)","Calc. (m)"]
[null,0,0.5,0.5,5e-05,5e-05,2,2,0.03,null,2.8284271247461903,0.0021604019432283983,0.6502159509108016,0.27187382138044097,1383.2577469575597,1382.9858731361792,9162,2792.5776,1409.591726863821]
[null,1,0.5,1,5e-05,0.0001,2,2,0.03,null,4,0.0018651604600101064,0.7146906668548929,0.3498016856721577,1381.2449657559405,1380.8951640702683,7450,2270.76,889.864835929732]
[null,2,0.5,1.5,5e-05,0.00015000000000000001,2,2,0.03,null,4.898979485566356,0.0017115313293398701,0.7553303899091145,0.40536726965896247,1379.4566198612656,1379.0512525916067,6250,1905,525.9487474083933]
[null,3,0.5,2,5e-05,0.0002,2,2,0.03,null,5.656854249492381,0.0016102668082155728,0.785558626444035,0.4500662059987724,1377.7957207924878,1377.345654586489,5900,1798.3200000000002,420.9743454135112]
[null,4,0.5,2.5,5e-05,0.00025,2,2,0.03,null,6.324555320336759,0.0015358645569621418,0.8098360915991236,0.4881045826699423,1376.222655109899,1375.7345505272292,5670,1728.2160000000001,352.4814494727709]
[null,5,0.5,3,5e-05,0.00030000000000000003,2,2,0.03,null,6.928203230275509,0.001477632702358559,0.8302281408257335,0.5215586904360419,1374.7159064802388,1374.1943477898028,5360,1633.728,259.53365221019726,2]
[null,6,-0.1,2.9,-1e-05,0.00029,2,2,0.03,null,6.81175454637056,0.0014882908941594721,0.8263978860979283,0.5151691047497554,1373.2329446819797,1372.71777557723,5140,1566.672,193.95422442277004,3]
[null,7,-0.1,2.8,-1e-05,0.00028,2,2,0.03,null,6.6932802122726045,0.0014994041119668915,0.8224518203281155,0.5086377133923126,1371.7390971789166,1371.2304594655243,4990,1520.952,149.7215405344757]
[null,8,-0.1,2.6999999999999997,-1e-05,0.00026999999999999995,2,2,0.03,null,6.572670690061993,0.0015110091079802318,0.8183821120279882,0.5019561303837806,1370.233890568943,1369.7319344385592,4875,1485.9,116.16806556144093,4]
[null,9,-0.1,2.5999999999999996,-1e-05,0.0002599999999999999,2,2,0.03,null,6.449806198638839,0.0015231471086100516,0.8141800851920482,0.4951151406753476,1368.7168124606478,1368.2216973199725,4770,1453.8960000000002,85.67430268002772,5]
[null,10,-0.1,2.4999999999999996,-1e-05,0.0002499999999999999,2,2,0.03,null,6.324555320336758,0.001535864556962142,0.8098360915991236,0.4881045826699422,1367.1873066278617,1366.699202045192,4680,1426.4640000000002,59.76479795480827]
[null,11,-0.1,2.3999999999999995,-1e-05,0.0002399999999999999,2,2,0.03,null,6.196773353931866,0.0015492140140587409,0.8053393578130247,0.4809132086534141,1365.6447673423513,1365.163854133698,4595,1400.556,35.392145866302144]
[null,12,-0.1,2.2999999999999994,-1e-05,0.0002299999999999999,2,2,0.03,null,6.06630035524124,0.001563255260980067,0.800677800581084,0.47352851787250455,1364.088532704832,1363.6150041869596,4525,1379.22,15.604995813040432,6]
[null,13,-0.1,2.1999999999999993,-1e-05,0.0002199999999999999,2,2,0.03,null,5.93295878967653,0.001578056657707094,0.795837802410476,0.46593655545345325,1362.5178767454884,1362.0519401900349,4490,1368.5520000000001,6.500059809965251]
[null,14,-0.1,2.099999999999999,-1e-05,0.0002099999999999999,2,2,0.03,null,5.796550698475774,0.0015936968332696357,0.7908039364827137,0.45812166826847245,1360.932,1360.4738783317316,4465,1360.932,0.4581216682684044,7]