Tools and Calculator's

all tools to be used at own-risk

Vertical Curve Calculator

Tool for Vertical Curve Geometry

Given the four independent variables (Speed, Incoming and Outgoing Grade and Length of Curve) all the derived values are presented and checked against CalTrans HDM Section 201.

Offset Inlet Capture Calculator

Uses HEC-22 to calculate capture for inlets having the grate offset from the gutter line (interior bypass).

Green Sheet (Cleanup)

The primary changes from the standard CalTrans Green Sheet are:

• reference of a single sheet for Runoff Coefficient and Intensity calcs (as opposed to copying to every sheet)
• elimination of masses of unclear and unused text (e.g., use of dropdown lists instead of 14 unused ground types)
• some missing equations were added and some checks were put in place
• Summary sheet 
  • I have made the area numbers and bypass flow fields as inputs for the individual sheets.  This is particularly useful when the reading from drainage area maps and especially when the areas and spacing changes.
  • I like seeing all the info for all the inlets in one page. It makes QC easier.  If you don't like summary sheets, delete it, but see the above note; you'll get some #REF errors, just key in the numbers from you drain maps or Flowmaster.
  • The included example has some extra columns because some of the inlets are offset from gutter; delete these columns.

Uncaptured opportunities

There are some opportunities for further cleanup.  

For example, the area percentage calcs are based on knowing the ratio of a given type to the total area.  The reality is that the area is known first and then calculated as a percentage later.  It makes sense to let the spreadsheet calculate this (paper trail (in-place calc), less transcribing, and easier to QC against the area source (dgn).

One argument against this change in the Green Sheet is that the review is looking at something new and therefore doesn't have confidence in the methodologies used here.  My argument is that since the original is completely unlocked, there is no guarantee whatsoever that the equations haven't been intentionally or unintentionally changed.  We can lock down the equation fields so that they're not accidentally changed.

Spread-based Inlet Spacer

more about this later.  complicated.  inlet_spacer.xls