These scripts update, sort and rank records based on input culvert parameters in a Microsoft Excel spreadsheet.
The needed inputs are based on an ArcGIS Collector database. Certain culvert criteria is used to evaluate whether a culvert needs to be analyzed further.
These scripts were developed to help a colleague sort and rank culvert inventory data. Culverts that were sized improperly, or were damaged are brought to a ranking level for replacement. Culverts are ranked based on weighted metrics, leaving the highest priority culverts at the top of the list.
Download the Microsoft Excel spreadsheet if you want to check it out.
This script was developed and tested on Microsoft Excel 2013
Michael Harris is the author of this script.
[StackOverflow] (http://stackoverflow.com/users/4530995/michael-harris)
[LinkedIN] (https://www.linkedin.com/in/michael-harris-366b0060/)
My colleague Ann T. provided the necessary information and requests to develop these scripts.
This code is available under the [MIT License.] (LICENSE)