¬ Click to return to my home page.

1D SEDIMENT TRANSPORT MORPHODYNAMICS

with applications to

RIVERS AND TURBIDITY CURRENTS

Excel Files

Click on the hyperlink to download the file.  Many of these files contain code in Visual Basic for Applications (VBA).  The code is directly available to the user.

NOTE A: The security level in Excel must be set to no higher than "Medium" in order to execute code with embedded VBA.  To set this level, from Excel click "Tools", then select "Macro", then select "Security", then click "Medium".  You may have to reboot your computer to make this effective.

NOTE B:  All the VBA code was written and checked using a PC.  Apparently some of the code will not run on a Mackintosh.  For example, the use of the "Round" function (for rounding numbers) leads to problem.  I am told that editing the code everywhere to modify "Round" to "Application.WorksheetFunction.Round" should allow the code to run on a Mackintosh.
File name & hyperlink Used in Chapter Description Embedded VBA?
RTe-bookIntroVBA.xls 2 Tutorial in programming in Visual Basic for Applications within Excel workbooks Yes
RTe-bookGSDCalculator.xls 2 Calculator for statistical characteristics of grain size distributions Yes
RTe-bookFallVel.xls 2 Particle fall velocity calculator No

RTe-bookRivers.xls

(do not update links)

 3 Basic data for bankfull geometry of rivers No
RTe-bookBackwater.xls 5 Spreadsheet for backwater calculations in open channel flow No
RTe-bookAcronym1.xls 7 Implementation of the Parker (1990) bedload transport relation for gravel mixtures Yes
RTe-bookWPHydResAMBL.xls 9 Implementation of the Wright-Parker (2004) formulation for hydraulic resistance combined with the Ashida-Michiue (1972) bedload formulation No

RTe-bookRouseSpreadsheetFun.xls

 10 Spreadsheet for calculating the Rouse-Vanoni profile of suspended sediment No

RTe-bookSuspSedDensityStrat.xls

 10 Tool for calculating the effect of density stratification on the vertical profiles of velocity and suspended sediment Yes

RTe-bookDepDisTotLoadCalc.xls

 11 Illustration of calculation of depth-discharge relation, bed load transport, suspended load transport and total bed material load for a large, low-slope sand-bed river No

RTe-bookAgDegNormal.xls

 14 Illustration of calculation of aggradation and degradation of a river reach using the normal flow approximation. Yes

RTe-bookAgDegNormalFault.xls

 14 Same as RTe-bookAgDegNormal.xls but with extension for calculation of the response to a sudden fault along the reach Yes

RTe-bookBedrockAlluvial Trans.xls

 16 Calculator for aggradation and degradation with a migrating bedrock-alluvial transition at the upstream end Yes

RTe-bookAgDegNormGravMixPW.xls

 17, 18 Calculator for aggradation and degradation of sediment mixtures in gravel-bed streams Yes

RTe-bookAgDegNormGravMixHyd.xls

 19 Calculator for aggradation and degradation of sediment mixtures in gravel-bed streams subject to cyclic hydrographs Yes

RTe-bookAgDegBW.xls

 20 Calculator for aggradation and degradation of a river reach using a backwater formulation Yes

RTe-bookBackwaterWrightParker.xls

 21 Calculator for backwater curves in sand-bed streams, including the effects of both skin friction and form drag due to skin friction Yes

RTe-bookDredgeSlotBW.xls

 21 Calculator for aggradation and degradation of sediment mixtures in gravel-bed streams subject to cyclic hydrographs Yes

RTe-bookRecircFeed.xls

 22 Calculator for approach to equilibrium in recirculating and feed flumes Yes

RTe-bookSteadyStateAg.xls

 25 Calculator for approach to equilibrium in recirculating and feed flumes No

RTe-book1DRiverwFPRisingBaseLevelNormal.xls

 25 Calculator for disequilibrium aggradation of a sand-bed river in response to rising base level Yes

RTe-bookAgDegNormSub.xls

 26 Calculator for evolution of upward-concave bed profiles in rivers carrying uniform sediment in subsiding basins Yes

RTe-bookAgDegNormGravMixSubPW.xls

 26 Calculator for evolution of upward-concave bed profiles in rivers carrying sediment mixtures in subsiding basins Yes

RTe-bookGravelSandTransition.xls

 27 Calculator for evolution of long profile of river with a migrating gravel-sand transition and subject to subsidence or base level rise Yes

RTe-bookBedrockIncisionWear.xls

 30 Calculator for evolution of long profile of a river incising due to wear in an uplifting basin Yes

RTe-bookSubsidingFan.xls

 33 Calculator for evolution of profiles of fans in subsiding basins Yes

RTe-book1DDeltaBW.xls

　

 34 Calculator for evolution of long profile of a river ending in a 1D migrating delta, using a backwater formulation Yes

RTe-book1DDeltaNorm.xls

　

 34 Calculator for evolution of long profile of a river ending in a 1D migrating delta, using the normal flow approximation Yes
¬ Click to return to my home page.