Two Excel applications using the SIDRA INTERSECTION API are available as utilities to provide additional capabilities for SIDRA INTERSECTION users.
- VOLUMES: This Excel application (VOLUMES_SI7_util.xlsm) allows specification of Volumes and related data within the Excel file, and processes a selected Site in a SIDRA INTERSECTION Project using data given in the Project file or in the Excel file, providing Volume Output, Intersection Output, Movement Output, Lane Output and Pedestrian Movement Output in Excel sheets.
- ANNUAL SUMS: This Excel application (ANNUALSUMS_SI7_util.xlsm) allows determination of yearly total values of various performance statistics (cost, fuel consumption, CO2 and other emissions, delay, effective stops, travel time, etc.) for several flow periods and for two design options / scenarios, and gives comparison statistics and charts. For more detailed information, refer to the User Guide. A NETWORK ANNUAL SUMS utility has also been prepared which is similar to ANNUAL SUMS for Sites. It will be available on the page.
The VOLUMES and ANNUAL SUMS utilities require MS Office 2010 / 2013 use with macro-enabled Excel file extension xlsm.
Before using the VOLUMES or ANNUAL SUMS utility for the first time, right click the file name or icon, select Properties in the menu, then select the General tab. If an Unblock button is shown, click the button to unblock the file. Otherwise various errors may occur during running of the utility.
For the use of VOLUMES and ANNUAL SUMS utilities, a SIDRA INTERSECTION Project file (extension sip7) needs to be prepared first. Once the Project file is ready, the Project should be closed in SIDRA INTERSECTION. Simultaneous use of the same Project in SIDRA INTERSECTION and any API application is not recommended. Otherwise, various problems and data updating issues may result due to trying to access the same Project from two different programs.
For detailed information on the use of VOLUMES and ANNUAL SUMS utilities, refer to SIDRA INTERSECTION 7 User Guide.