PTV Vissim Result and Evaluation using Excel Part 2

Introduction

In this tutorial, we will learn how to analyze results and evaluate your network using Excel, specifically focusing on the capabilities of PTV Vissim. This guide will help you effectively interpret data and improve your network's performance by leveraging Excel's analytical tools.

Step 1: Export Data from PTV Vissim

• Open your PTV Vissim project.
• Navigate to the results section of the software.
• Select the data you wish to analyze (e.g., traffic flow, delays).
• Export the selected data to an Excel-compatible format, such as CSV.
• Save the file to a known location on your computer for easy access.

Step 2: Open and Organize Data in Excel

• Launch Microsoft Excel and open the exported data file.
• Review the data layout and ensure that it is organized in a tabular format.
• Consider the following tips for organization:
  • Use headers for each column (e.g., time, volume, speed).
  • Remove any unnecessary rows or columns to streamline your analysis.

Step 3: Data Cleaning and Preparation

• Check for any inconsistencies or missing values in your dataset.
• Use Excel functions to clean the data:
  • Remove duplicates: Select data, go to the Data tab, and click on "Remove Duplicates."
  • Fill missing values: Use the IF statement or fill with averages as needed.
• Ensure that all data types are correctly formatted (e.g., numbers, dates).

Step 4: Analyze the Data

• Use Excel's built-in analytical tools to evaluate the data:
  • Sort and Filter: Use these features to focus on specific time periods or traffic conditions.
  • Pivot Tables: Create a Pivot Table to summarize and analyze complex data sets.
    • Select your data range, go to the Insert tab, and choose "PivotTable."
    • Drag and drop fields to analyze traffic patterns and performance metrics.
• Create charts to visualize your findings:
  • Use line charts for trends over time.
  • Bar charts can compare different locations or conditions.

Step 5: Evaluate Network Performance

• Establish key performance indicators (KPIs) relevant to your analysis, such as:
  • Average speed
  • Delay times
  • Volume-to-capacity ratios
• Compare the KPIs against your expectations or standards to evaluate overall network performance.

Step 6: Document Findings and Recommendations

• Summarize your analysis in a clear and concise manner.
• Create a report that includes:
  • Key findings from your analysis.
  • Visual aids (charts, tables) to support your conclusions.
  • Recommendations for improvements based on your findings.

Conclusion

In this tutorial, we covered the essential steps for analyzing PTV Vissim results using Excel, from exporting data to documenting your findings. By following these steps, you can effectively evaluate your network's performance and make informed decisions for improvements. For further learning, explore advanced Excel functions or consider additional tutorials on network evaluation techniques.