ATT 1 - Naval Base Guam Bldg. 3 Microwaves.xlsx

RFQ

For Information Only

Provide dimensions in Inches HNC Unit Cost HNC Total Cost EDC-I: Hide these columns before submitting file.

Select correct entries in the boxes above.

These columns shows open market costs and difference from GSA

When completing this form, do not delete or alter any columns or workbook tabs.

Tech Eval HNC USE ONLY

Instructions

If there are multiple buildings, see instructions below.

NOTE: Types of Delivery are defined in the table on the right of this page.

NOTE: MAKE SURE SUBTOTALS AND TOTALS ARE INCLUSIVE OF NEW ROWS!

B. Title the Document "1st TR - Vendor - Project Name.docx" for the Tech Eval. Each item will have a "block" of 14 rows, to allow for multiple rounds of tech evals. When dealing with a specific item, please remember there are 14 rows to copy.

NOTE: DO NOT COMPLETE THE TECH REVIEW IN THE ATT 1 TEMPLATE.

2 To add more lines to the RFQ Tab:

A. When lines are added to the RFQ tab you must also insert more rows in the Tech Eval tab.

B. Highlight the 14 rows that reflect the tech eval block for the item directly above.

C. Copy those onto the end, or in whatever location is required, repeat for each new item.

D. Hand change the 7 formulas that pull data from the RFQ tab. They are in the first 5 lines of the item block. The 2 digit cell numbers will need to be changed to 85. The next one will be changed to 86 and so forth.

3 To delete lines from the RFQ Tab:

A. If lines are deleted from the RFQ Tab, you will need to delete rows in the Tech Eval tab.

B. The item block in the Tech Eval tab will have the #REF! error. If you come across a block that is not needed, either Delete or Hide those 14 rows.

B. To update the Att 1 for a change of product manually highlight cells in yellow that need changing (modifying).

C. For a change in quantity, this includes the quantity on the Locations matrix, the total quantity for the item on the Locations matrix, and the quantity on the RFQ table, Highlight the yellow cell(s) at the bottom of the Locations matrix and use Format Paint to update the cells above. NOTE: Tan lines cannot be changed to yellow the normal way.

Prep Tab