This file is intended to get you started with these files.  For additional documenting see the Design Manual: "http://www.iowadot.gov/design/dmanual/manual.html?reload" All of these files are compatable with Office 2007.  Any other version of Office may cause errors with this program. 






Earthwork.xlsm
	This file is used to generate the tabulations 107-28 in the T sheets.  No other spreadsheets are required to develop print sheets.




ExcelTabulations.xlsm
	This file is used in conjunction with data entry spreadsheets.  It will be used with sheet types C, G, J, and S.  The data entry sheets can be found on the web at the following location: "http://www.iowadot.gov/design/tnt/ExcelTabs/ExcelTabsForWeb.zip".  To make this file work properly you will need to open the version of this file that will be your seed, and set the path to the data entry sheets.  To adjust this path you will need to have this file open and the macros enabled.  Select the Add-Ins tab then the Modify Tools button and Unhide index.  This will unhide a worksheet on the right side of your tabs.  Select the index tab and correct the file location to coincide with the locations on your network or computer.  An example of the paths that need to be corrected is: "W:\Highway\Design\RoadDesignDetails\ExcelTabs\"
         




ExcelTabulationsStormSewer.xlsm
	This file is used to produce tabulations 104-5A or 104-5B. This file is similar to the Excel Tabulation file, but has slight changes to deal with the offset rows on in the 104-5B tab.
