These low cost Excel spreadsheets include selections from many of the categories of spreadsheets that we have for sale.
This Excel spreadsheet gives the NRCS dimensionless unit hydrograph, which can be used to develop a storm hydrograph for a specific basin based on information about that basin.
This Excel spreadsheet calculates the density of air at specified temperature and pressure using the ideal gas law, working in either U.S. units or S.I. units. It will also work for other gases of known molecular weight.
Convenient templates for calculating the standard compound-interest factors used in engineering economics and in finance: present value, future value, uniform series of payments, gradient series, and geometric series. This file has three tabs, one for discrete compounding, one for continuous compounding of discrete cash flows, and one for continuous compounding of continuous cash flows. Easier to use than a hand-held financial calculator and at a fraction of the cost.
This Excel workbook will calculate the compressibility factor of a gas using the Redlich-Kwong equation of state, based on user input values for temperature and pressure of the gas and critical temperature and pressure of the gas. There is a worksheet for U.S. units and one for S.I. units.
Spreadsheets for calculating the principal stresses, principal angle, maximum in-plane shear stress, and stresses acting on a plane inclined at an angle with respect to the coordinate axes, all for a state of plane stress. Faster, easier to use, and less prone to errors than using your calculator—with the spreadsheet you never have to re-enter your data and formulas to double-check your answer.
This handy Excel spreadsheet will calculate the Moody friction factor for specified pipe diameter, length, roughness, and flow rate, along with fluid density and viscosity. An iterative solution of the Colebrook equation is used and the equations are shown on the spreadsheet, so you can see how the friction factor value is determined. Calculations are in U.S. units.
This handy friction factor calculator is an Excel spreadsheet that will calculate the Moody friction factor for specified pipe diameter, length, diameter, roughness and flow rate along with fluid density and viscosity. An iterative solution of the Colebrook equation is used and the equations are shown on the spreadsheet, so you can see how the friction factor value is determined. Calculations are in S.I. units.
This spreadsheet uses the Manning Equation to calculate the flow rate and velocity for a rectangular open channel with specified channel width, flow depth, channel slope and Manning roughness coefficient. Calculations use U.S. units
This spreadsheet uses the Manning Equation to calculate the flow rate and velocity for a rectangular open channel with specified channel width, flow depth, channel slope and Manning roughness coefficient. Calculations use S.I. units
This workbook has two tabs involving the allowable stress design of a simply supported beam carrying a uniformly distributed load. In the first tab, input consists of span length, elastic modulus, live load, dead load, allowable bending stress, deflection limit for live load, and deflection limit for live plus dead load (serviceability requirements). The workbook then calculates the maximum moment, maximum shear, elastic section modulus, and minimum moments of inertia required to satisfy the constraints on deflection. In the second tab, a check is made of a known design to see if strength and deflection requirements are met. Input is the same as in the first tab, with the addition of the elastic section modulus and moment of inertia. The workbook then determines whether the maximum moment, deflection under live load, and deflection under live plus dead load are less than the corresponding allowables. Both SI and US Customary units are allowed. All formulas are given, and the Excel code can be easily customized to meet specialized requirements of a particular user.
This Excel spreadsheet calculates the average atmospheric pressure at a specified elevation above sea level. The calculations may be in either U.S. units or S.I. units.
This Excel spreadsheet calculates air viscosity at a given temperature and pressure in either U.S. units or S.I. units.
This Excel spreadsheet calculates the viscosity of a gas at a specified gas temperture. User inputs required are the gas temperature, Sutherland's constant for the gas, and the viscosity of the gas at some specified reference temperature. A table with values for Sutherland's constant along with values for gas viscosity at one or more reference temperatures is provided for 25 gases. Calculations may be made in either S.I. or U.S. units.
This standalone program (not a spreadsheet) provides practice for learning the principles underlying shear and bending-moment diagrams. The program contains over 50 exercises, which have been chosen to represent all common boundary conditions and load cases. The program is highly interactive: starting at the origin of the shear diagram, the user calculates the coordinates of the next point where the diagram changes slope or direction. Then the user plots this point and specifies the type of curve connecting the two points. The user proceeds in a similar manner to plot the next point on fht diagram and connect it with the most recently plotted point. Continuing in this fashion, the user completes the shear diagram and then goes on to the moment diagram. Extensive Help screens are available which describe the theory and provide the answer for the current step when needed. A quiz facility is also provided for use of the program in a classroom setting.
Download and Installation: Note that this download is an exe program not an Excel spreadsheet. After you download the file, "VandM selfextract.exe," click on it and then on "Run." The program will unzip three files to a folder, which you should choose so that you can easily find it later. Your unzipped files should be: SETUP.LST, VandM.CAB, and setup.exe. Do not unzip VandM.CAB. Click on setup.exe and follow the instructions on the screen to install the program on your computer.
You may get a warning from your browser stating that the file is an exe file and asking if you want to continue. The file is safe and does not contain any viruses.