To use spreadsheets to modify structures
Send bridge or tunnel information to a spreadsheet, modify the structure's information in the spreadsheet, then update the structure in your drawing from the changes.
To send structure information to a spreadsheet
Select the structure.
Right-click and select Send to Spreadsheet
Create New.Enter a name or accept the default and click Save.
Microsoft Excel opens a spreadsheet displaying the information from the selected structure.
Edit the spreadsheet. Note that there are tabs for each component.
The fields in blue are editable. The fields in black are not. There are a few exceptions to these rules which are noted below.
Save the updated spreadsheet.
| Tab | Not editable |
|---|---|
| Bridge | Creation date, Termination date |
| Deck | Creation date, Termination date |
| Pier | Creation date, Termination date |
| Foundation | Height above ground, Lateral offset, Longitudinal offset, Skew, Creation date, Termination date |
| Abutment | Creation date, Termination date |
| Girder Groups | Start gap, End gap, Start spacing, End spacing, Girders in plan, Creation date, Termination date |
| Girders | Start offset, End offset, Creation date, Termination date |
To update the structure with information from the spreadsheet
- In your InfraWorks model, right-click the structure, and select Send to Spreadsheet Update Existing.
To open an existing spreadsheet
In your InfraWorks model, right-click the structure, and select Send to Spreadsheet
Open Existing.The last spreadsheet you edited using Create New opens for updating.