STATE OF TENNESSEE
DEPARTMENT OF TRANSPORTATION
DIVISION OF MATERIALS AND TESTS
6601 CENTENNIAL BLVD.
NASHVILLE, TENNESSEE  37243-0360

MATERIALS AND TESTS ELECTRONIC FORMS

                                                                                                                                                                                   
�
CONTENTS

The Materials and Tests form directory consists of dozens of files including the Read Me file, the Correcting a Report file, the Form Index, and the actual form files.

Each Materials and Tests form file is in Excel format; each file contains the following:

•	a worksheet on which data is entered and can be printed as a form
•	one or more worksheets with examples of the form properly completed
•	an About worksheet with special instructions particular to the form and background information

An index of the forms is in the file called Form Index.  The index can be sorted as data to suit your needs. 

The file Correcting a Report is from the Forms and Reporting Policy.  

The forms are protected and cannot be modified; however, the cells in which you enter data are not protected.  You should only change the cell formatting (font settings, alignment, etc.) when absolutely necessary.  Some cells automatically calculate and are also protected.
                                                                                                                                                                                   
¿
INSTALLING THE FORMS TO YOUR OWN DRIVE FROM THE INTERNET

To make the best use of the Materials and Tests forms, follow these instructions:

1.  Create a new folder called Materials and Tests located in the Microsoft Office Templates folder.  

2.  Open the form you want to download.

3.  Choose File_Save As.

4.  Save in: the new folder you created

	C:/Program Files/Microsoft Office/Templates/Materials and Tests

5.  For File name: type in the form number (i.e. DT0254E).

6.  Save as type: Template.

7.  Then click Save.

INSTALLING THE FORMS TO YOUR OWN DRIVE FROM THE CD

The forms on the CD can be used individually as needed.  If you wish to install all of the forms at once, use WinZip to unzip the FormsZip file.  A can download WinZip free from one of a number of sites on the Internet.

þ
USING DOWNLOADED FORMS

1.  Open the Microsoft application, either Excel or Word.  (If you are opening a form from Windows Explorer, double-click on the form number.)

2.  Choose File_New

3.  Choose the Materials and Tests tab.

4.  Then choose the form you want.

5.  Complete the form.

USING THE FORMS FROM THE INTERNET

1.  Select the form from the index.  The form will open in the appropriate application.

2.  Complete the form.
                                                                                                                                                                                   
Í
SAVING THE FORMS

1.  Choose File_Save As.

2.  Save in: a folder of your choice for completed forms.

3.  Choose a File name:.

4.  Save as type: Microsoft Excel Workbook.

5.  Then click Save.
                                                                                                                                                                                   
™
SUBMITTING COMPLETED FORMS ELECTRONICALLY

Simply attach the completed form as a Microsoft Excel Workbook in your email application.
                                                                                                                                                                                   
G
SUGGESTIONS

If you have any suggestions for improving the forms, please contact the forms committee at Headquarters, Materials and Tests, Nashville.