Converting Spreadsheet-Based Scenario Definitions to OpenSCENARIO Files

The goal of this project was to create a tool to convert spreadsheet-based scenario definitions into the OpenSCENARIO standard format for easy exchange, usability, and storage for Ford engineers. Through standardization, the tool allowed for scenario reuse regardless of the simulation tool and test case format. The tool was first used to support automated conversion of scenarios defined in complicated spreadsheets to the beta version of OpenSCENARIO. This tool is capable of showing the resulting scenario in the Automated Driving Toolbox™ drivingScenario tool and exporting OpenSCENARIO 0.9.1 files representing the corresponding CarSim scenarios. Lastly, the app was modified so that users could enter information required by OpenSCENARIO to build up scenarios from other documentation—enabling reusability and easy shareability across Ford.