Roadway Design Question and Answer Forum
General
Question:
After importing the earthwork log files into the earthwork volume spreadsheet, why does the program fail to create the cross section X-1A sheet?
Answer:
The reason why the X-1A sheet was not generated is because the log files have a plus "+" symbol in the name. Simply
rename the log files, highlighted below, without the plus symbols.
XS Index Sheet
Base on this question, we have identified the need to organize our cross section sheets for larger Projects.
Rather than putting the stations in the log file name, a XS Index Sheet has been added into our Roadway Earthwork
XSC Volume Summary Workbook (xsc_ew_volumes.xls).
This sheet is populated with known data when the menu item "Place earthwork onto Summary Sheet" is selected.
While the X-1A sheet (Summary Sheet) is being created at this step, the XS Index Sheet is simultaneously
being populated in the background.
Note that the Location and Sheet Number columns ("unknown" to the VBA program at the time) will still have to
be entered manually.
On larger Projects with over 100 XS sheets, we can benefit greatly from this spreadsheet.
