140229-SPM-RMS SUBMITTAL.xlsx

1- 799

RMS SUBMITTAL REGISTER INPUT FORM CONTRACT NUMBER DELIVERY ORDER

TITLE AND LOCATION

Button Administrator: Administrator:

Excel Submittal Register Input Template – Instructions By Alan Korslien /Doug Ramsey June 6, 2003 Revised: 2/1/2010 by Gerald McKoy @ RMS Center Version: 6.0

The Excel submittal register input template is used to create a batch input file to feed into RMS or QCS. The Excel format allows flexibility in getting submittal data into the RMS/QCS systems; both from a user familiarity standpoint (with Excel), and the editing capability available in Excel (cut & paste, insert rows, etc.) RMS Import/Export-Submittal screen has the option of selecting this template or the batch input file created within Specsintac. However, Contractors must enter the data in QCS either by hand or using this template. The contract will indicate who is to provide the submittal register.

There are a few restrictions in using the template:

1. Before starting your input, if you are starting out with the “blank” template file, make a copy of the file, specific to your project. i. e. Ph6A_MFH_submittal_register.xls.

2. Do not alter the shaded areas of the template. The worksheet is protected, the user cannot normally make structural changes to the template.

3. Input contract number, DO number and title and location. This data does not get imported into RMS/QCS, but will be shown as a pre-import "prompt" to remind you which project's submittal data you are importing.

4. Enter data starting in the first available data row (row 8) and continue without blank rows between data items. Blank rows at the end of the sheet are acceptable and will not affect the import operation.

5. There MUST be data in columns A, B, & C. Column D thru O must have one and only one "X" in a column. Column P thru U must have one and only one column with an "X". Columns V thru AA must have one and only one column with an "X".

6. When inputting the X’s in columns D through AA, use the tab key or cursor to navigate. Also, do not enter any blanks in these fields with the spacebar.

7. The worksheet is set up with 800 rows for data. If this needs to be increased, contact you Project Engineer or your RMS representative for instructions.

8. When you have completed your input and editing, save the “xls” file.

IF NOT IMPORTING DATA INTO THE RMS/QCS SYSTEM(S), DISREGARD BELOW INSTRUCTIONS

9. You must create a ".CSV” (comma delimited) formatted file from the "xls" file for importing into RMS as follows:

a. Save-as

b. Pick file type of: CSV (MS DOS) (*.csv)

c. Enter filename: (default will be the name of the .xls file) i.e. Ph6A_MFH_submittal_register_import.csv

d. Then click : “OK” and “Yes”

10. The “.csv” file formated file has been saved. Close out of ".cvs" file and Select “No” when asked to save changes to the “csv” file.

11. The “.csv” file is now ready for import into RMS/QCS.

<-----Right click for Instructions TYPE OF SUBMITTAL CLASSIFICATION REVIEWING OFFICE

x x x x x x x x x x x x x

800- 1600

RMS SUBMITTAL REGISTER INPUT FORM CONTRACT NUMBER DELIVERY ORDER

TITLE AND LOCATION

Button Administrator: Administrator:

Excel Submittal Register Input Template – Instructions By Alan Korslien /Doug Ramsey June 6, 2003 Revised: 2/1/2010 by Gerald McKoy @ RMS Center Version: 6.0

The Excel submittal register input template is used to create a batch input file to feed into RMS or QCS. The Excel format allows flexibility in getting submittal data into the RMS/QCS systems; both from a user familiarity standpoint (with Excel), and the editing capability available in Excel (cut & paste, insert rows, etc.) RMS Import/Export-Submittal screen has the option of selecting this template or the batch input file created within Specsintac. However, Contractors must enter the data in QCS either by hand or using this template. The contract will indicate who is to provide the submittal register.

There are a few restrictions in using the template:

1. Before starting your input, if you are starting out with the “blank” template file, make a copy of the file, specific to your project. i. e. Ph6A_MFH_submittal_register.xls.

2. Do not alter the shaded areas of the template. The worksheet is protected, the user cannot normally make structural changes to the template.

3. Input contract number, DO number and title and location. This data does not get imported into RMS/QCS, but will be shown as a pre-import "prompt" to remind you which project's submittal data you are importing.

4. Enter data starting in the first available data row (row 8) and continue without blank rows between data items. Blank rows at the end of the sheet are acceptable and will not affect the import operation.

5. There MUST be data in columns A, B, & C. Column D thru O must have one and only one "X" in a column. Column P thru U must have one and only one column with an "X". Columns V thru AA must have one and only one column with an "X".

6. When inputting the X’s in columns D through AA, use the tab key or cursor to navigate. Also, do not enter any blanks in these fields with the spacebar.

7. The worksheet is set up with 800 rows for data. If this needs to be increased, contact you Project Engineer or your RMS representative for instructions.

8. When you have completed your input and editing, save the “xls” file.

IF NOT IMPORTING DATA INTO THE RMS/QCS SYSTEM(S), DISREGARD BELOW INSTRUCTIONS

9. You must create a ".CSV” (comma delimited) formatted file from the "xls" file for importing into RMS as follows:

a. Save-as

b. Pick file type of: CSV (MS DOS) (*.csv)

c. Enter filename: (default will be the name of the .xls file) i.e. Ph6A_MFH_submittal_register_import.csv

d. Then click : “OK” and “Yes”

10. The “.csv” file formated file has been saved. Close out of ".cvs" file and Select “No” when asked to save changes to the “csv” file.

11. The “.csv” file is now ready for import into RMS/QCS.

<-----Right click for Instructions TYPE OF SUBMITTAL CLASSIFICATION REVIEWING OFFICE