Creating a searchable index for rolling stock using TS_Tools and Excel

[AmericanSteam]

Open TS_Tools
Go To Scenarios tab and open
Select Scenario Properties .xml and let it run
Go to Route Building Tools and open
Select Extract Route Properties .xml and let it run
Go to Edit Assets/Content
Open Assets Editor. Check the boxes for Rolling Stock Only, Exclude PreLoad, and Default Folders.
Click Add to list. Let this run, it may take an hour or more if you have a lot of assets.
After it is finished, select Save List, then select save as an EXCEL Workbook file. Open Reports/OpenExcel reports and drop where you want to store it.

Note: you will need of a basic knowledge of Excel to configure your new spreadsheet.

Once you have created your EXCEL file you will need to modify it using tools in EXCEL to set the text, column name, width, height, and sort alphabetically. Then save it as an Excel Workbook to your desktop.

To search for an Asset, Use Ctrl+f and insert the name of what you are searching for e.g CN, caboose or GP40-2. Then select find next or all. Expand the search box and scroll through the list and select the asset that you want and the the row will be highlighted on the spreadsheet and the Asset folder where the asset is stored. You can then add that folder to the asset drop down in the editor.

[harryadkins]

Nice!