{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ManningUS","QManning","ManningNTable"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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":"ManningUS","index":0,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":true,"merged":[[15,0,15,2],[7,0,7,2]]}
["Manning's Equation Calculator "]
["Methods:  ","Uses VBA Function to compute discharge, given Manning's n, Flow Area, Hydraulic Radius, and Friction Slope"]
[null,"Function name is QMANNUS(N,AREA,HYD.RADIUS,SLOPE)"]
["Remarks:","This variant uses the US Customary form of Manning's equation"]
[]
[]
[]
["INPUT"]
["ITEM","VALUE","UNITS"]
["Conduit Description","Smooth, well-packed earth; rough stone walls; channels excavated in solid, soft rock; little curving channels in solid loess, gravel, or clay with silt deposits, free from growth and in average condition"]
["Manning's n",{"$f":"INDEX(ManningNTable!B3:B25,MATCH(ManningUS!B10,ManningNTable!A3:A25,0))","v":0.02}]
["Area",98.7,"square feet (ft^2)"]
["Hyd. Radius",2.41,"feet (ft)"]
["Slope",1.4300000000000001E-3,"dimensionless (ft/ft)"]
[]
["OUTPUT"]
["Discharge",{"$f":"QMANNUS(B11,B12,B13,B14)","v":499.82672388953569},"cubic feet per second (ft^3/s)"]

{"sheet":"QManning","index":1,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[[9,0,9,2],[17,0,17,2]]}
["Manning's Equation Calculator "]
["Methods:  "]
["     Uses VBA Function to compute discharge, given "]
["     Manning's n, Flow Area, Hyd. Radius, and Friction Slope"]
["     Uses Pull-Down-List to select Manning's N from tabulated values"]
["     Function name is QMANNUS(N,AREA,HYD.RADIUS,SLOPE)"]
["Remarks:"]
["     This variant uses the US Customary form of Manning's equation"]
["     Coding: TGC 2014-11-21"]
["INPUTS"]
["ITEM","VALUE","UNITS"]
["Conduit Description","Smooth, straight surfaces; enameled or glazed coating; glass; lucite; brass","Pull-Down-Menu"]
["Manning's n",{"$f":"INDEX([1]ManningNTable!B3:B25,MATCH([1]ManningUS!B9,[1]ManningNTable!A3:A25,0))","v":0.02},"none (empirical s/ft)"]
["Area",46,"square feet (ft^2)"]
["Hyd. Radius",2.41,"feet (ft)"]
["Slope",1.4300000000000001E-3,"dimensionless (ft/ft)"]
[]
["OUTPUTS"]
["ITEM","VALUE","UNITS"]
["Discharge",{"$f":"QMANNUS(B13,B14,B15,B16)","v":232.94862511569036},"cubic feet per second (ft^3/s)"]

{"sheet":"ManningNTable","index":2,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Manning's n Values "]
["Description","Manning's n","Source"]
["Smooth, straight surfaces; enameled or glazed coating; glass; lucite; brass",8.9999999999999993E-3,"adapted from Simon, A.L., and Korom, S.F. 1997. Hydraulics 4ed. Prentice Hall, Ohio 443p.",{"$f":"A3","v":"Smooth, straight surfaces; enameled or glazed coating; glass; lucite; brass"}]
["Planed and fitted lumber boards; smooth metal; cement plaster; smooth tar or paint coating",0.01,"adapted from Simon, A.L., and Korom, S.F. 1997. Hydraulics 4ed. Prentice Hall, Ohio 443p."]
["Smooth mortar (1/3 sand) without projections, in straight alignment",1.0999999999999999E-2,"adapted from Simon, A.L., and Korom, S.F. 1997. Hydraulics 4ed. Prentice Hall, Ohio 443p."]
["Fitted, but unplaned boards; steel trowled concrete, in straight alignment",1.2E-2,"adapted from Simon, A.L., and Korom, S.F. 1997. Hydraulics 4ed. Prentice Hall, Ohio 443p."]
["Straight, clean, smooth surfaces without projections; good boards; carefully built brich wall; wood trowled concrete; smooth, dressed ashlar (masonry)",1.2999999999999999E-2,"adapted from Simon, A.L., and Korom, S.F. 1997. Hydraulics 4ed. Prentice Hall, Ohio 443p."]
["Good wood, metal, or concrete surfaces with some curvature, very small projections, slight moss or algae growth or gravel deposition; shot concrete surfaced with trowled mortar",1.4E-2,"adapted from Simon, A.L., and Korom, S.F. 1997. Hydraulics 4ed. Prentice Hall, Ohio 443p."]
["Rough brick; medium quality cut stone surface; wood with algae or moss growth; rough concrete; riveted steel",1.4999999999999999E-2,"adapted from Simon, A.L., and Korom, S.F. 1997. Hydraulics 4ed. Prentice Hall, Ohio 443p."]
["Very smooth and straight earth channels, free from growth; stone rubble set in cement; shot, untroweled concrete; deteriorated brick wall; exceptionally well excavated and surfaced channel cut in natural rock",1.7000000000000001E-2,"adapted from Simon, A.L., and Korom, S.F. 1997. Hydraulics 4ed. Prentice Hall, Ohio 443p."]
["Well-built earth channels covered with thick, uniform silt deposits; metal flumes with excessive curvature, large projections, accumulated debris",1.7999999999999999E-2,"adapted from Simon, A.L., and Korom, S.F. 1997. Hydraulics 4ed. Prentice Hall, Ohio 443p."]
["Smooth, well-packed earth; rough stone walls; channels excavated in solid, soft rock; little curving channels in solid loess, gravel, or clay with silt deposits, free from growth and in average condition",0.02,"adapted from Simon, A.L., and Korom, S.F. 1997. Hydraulics 4ed. Prentice Hall, Ohio 443p."]
["Deteriorating uneven metal flume with curvatures and debris; very large canals in good condition",0.02,"adapted from Simon, A.L., and Korom, S.F. 1997. Hydraulics 4ed. Prentice Hall, Ohio 443p."]
["Small, human-made earth channels in well-kept condition; straight natural streams with rather clean, uniform bottoms without pools and flow barriers, cavings, and scours of the banks",2.5000000000000001E-2,"adapted from Simon, A.L., and Korom, S.F. 1997. Hydraulics 4ed. Prentice Hall, Ohio 443p."]
["Ditches; below-average human-made channels with scattered cobbles in bed",2.8000000000000001E-2,"adapted from Simon, A.L., and Korom, S.F. 1997. Hydraulics 4ed. Prentice Hall, Ohio 443p."]
["Well-maintained large floodway; unkept artifical channelswith scours, slides, considerable aquatic growth; natural stream with good alignment and fairly constant cross section",0.03,"adapted from Simon, A.L., and Korom, S.F. 1997. Hydraulics 4ed. Prentice Hall, Ohio 443p."]
["Permanent alluvial rivers with moderate changes in cross section, average stage; slightly curving intermittent streams in very good condition",3.3000000000000002E-2,"adapted from Simon, A.L., and Korom, S.F. 1997. Hydraulics 4ed. Prentice Hall, Ohio 443p."]
["Small deterioriated artifical channels, half choked with aquatic growth; winding river with clean bed, but with pools and shallows",3.5000000000000003E-2,"adapted from Simon, A.L., and Korom, S.F. 1997. Hydraulics 4ed. Prentice Hall, Ohio 443p."]
["Irregularly curving permanent alluvial stream with smooth bed; straight natural channels with uneven bottom, sand bars, dunes, few rocks and underwater ditches",0.04,"adapted from Simon, A.L., and Korom, S.F. 1997. Hydraulics 4ed. Prentice Hall, Ohio 443p."]
["Lower section of mountainous streams with well-developed channel with sediment deposits; intermittent streams in good condition; deteriorated artifical channels, with moss and reeds, rocks, and slides",0.04,"adapted from Simon, A.L., and Korom, S.F. 1997. Hydraulics 4ed. Prentice Hall, Ohio 443p."]
["Artifical earth channels partially obstructed with debris, roots, and weeds; irregularly meandering rivers with partially grown-in or rocky bed; developed flood plains with high grass and bushes",6.7000000000000004E-2,"adapted from Simon, A.L., and Korom, S.F. 1997. Hydraulics 4ed. Prentice Hall, Ohio 443p."]
["Mountain ravines; fully ingrown small artifical channel; flat flood plains crossed by deep ditches",0.08,"adapted from Simon, A.L., and Korom, S.F. 1997. Hydraulics 4ed. Prentice Hall, Ohio 443p."]
["Mountain creeks with waterfalls and steep ravines; irregular flood plains; weedy and sluggish natural channels obstructed with trees",0.1,"adapted from Simon, A.L., and Korom, S.F. 1997. Hydraulics 4ed. Prentice Hall, Ohio 443p."]
["Rough mountain creeks; swampy, heavily vegetated rivers with logs and driftwood on the bottom; flood plain forests with pools",0.13300000000000001,"adapted from Simon, A.L., and Korom, S.F. 1997. Hydraulics 4ed. Prentice Hall, Ohio 443p."]
["Mudflows; very dense flood plain forests; watershed slopes",0.22,"adapted from Simon, A.L., and Korom, S.F. 1997. Hydraulics 4ed. Prentice Hall, Ohio 443p."]