Skip to content

2023-11 Import Spreadsheet Update

The TREDIS team has versioned the import spreadsheet to support the new features being released, including the Safety Incident Counts interfaces, new mode factors for injury severity values and crashes per vehicle, and Quantity and Unit Costs inputs. (These are detailed in two other Release Notes published in November 2023 with this Note.)

Though users are encouraged to use the new version of the import spreadsheet, the prior version, 6.01 (dated 2021-08-04), remains supported for import. All currently backed-up projects and import spreadsheet preparation processes are reverse compatible.

Starting from November 3, 2023, when you download a new template or when you export/back up projects, they will now be exported in this new version (6.02).

These improvements, including the update to the import spreadsheet, were produced in collaboration with Michigan DOT and funded by the State of Michigan.

The new import spreadsheet features these changes from Version 6.01:

  • Basic Safety Incident Count inputs, Advanced Safety Incident Count inputs, and Quantity and Unit Cost inputs each have dedicated tabs to be imported with the appropriate data.
  • The Project tab now includes a column to indicate whether the project uses rates, basic counts, or advanced counts of crash outcomes.
  • The Mode Factors tab now has factors ascribing a social cost to each level of injury severity – A, B, C, and O. (The existing "injury" level has been more accurately relabeled "U" for "unknown." This has always been what it represented, but its labeling was not as clear before when it was simply "$ per Injury".)
  • The Mode Factors tab now has a column for "Vehicles per Crash."
  • The Travel input tabs – Travel Facility Based and Travel O-D Based – now have columns for "Crashes per 100m VMT".