AIMSOIR is a spreadsheet-based asset management reporting tool. The tool requires data to be captured in a particular format and will aid in creating graphs, tables, and other visuals describing the state of your infrastructure. Two styles of reports are currently available:

Preliminary State of Infrastructure Report
This report is intended to provide a high-level overview of the current state of municipal infrastructure through the following tables and figures:

  • 30-year projected capital expenditures
  • replacement cost
  • annual reserves required
  • mapping of infrastructure condition

Risk-Based Prioritization Report
This report is intended to aid in creating operational and capital strategies by identifying high risk assets through a prioritization process. Probability and consequence of failure of municipal infrastructure is required for this report. This report generates the following tables and figures:

  • 5-year plan
  • 25-year plan

We are currently in the process of finalizing this spreadsheet and supporting manuals for distribution. Please email if you are interested in obtaining a copy of this tool before the formal release.