Instuctions for spreadsheet.doc

DOC document 44 KB Posted

Attached to
Printing, Letterhead Statioary
Solicitation number
RFQ - 18P - 07100900000000000297
Issued by
Kennebec County, Maine

About this file

This file provides instructions for completing a catalog template spreadsheet required by the State of Maine to load vendor contract information into the AdvantageME procurement system. The document outlines the specific format and data requirements for submitting product catalogs related to a Printing and Letterhead Stationery contract opportunity. Vendors must complete the Catalog_Template.xls spreadsheet without altering its format or deleting optional columns, ensuring data integrity for system upload.

The spreadsheet template includes 20 fields with specific requirements for data entry. Required fields include Supplier Part Number (formatted as text, 32 characters maximum), Supplier Name (60 characters), Commodity Code using NIGP 5-digit codes (alpha numeric, 5 characters), Item Description (60 characters), Extended Description (1500 characters), Unit of Measure selected from an attached reference file (4 characters), and List Price (14 digits before and 6 after the decimal point). Optional fields include Manufacturer Name and Part Number, Product Category, Model, Drawing, Piece, Serial Number, Specifications, Size, Color, and Picture File Name (255 characters). The Vendor Customer Code field must be left blank for completion by the State of Maine Buyer. Vendors are directed to reference the NIGP Codes resource available on the Maine Department of Purchases website for proper commodity code classification.

View the file

Other files

File Type Posted
LetterheadQuoteOct07.rtf RTF text file
LetterheadSpreadsheet.xls XLS spreadsheet
Clauses Extenison Overrun 3.doc DOC document
Conditions and Instructions to Bidders.doc DOC document

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Accompanying this memo is the Catalog_Template.xls Microsoft Excel spreadsheet you need to complete and return to us to load your contract into AdvantageME. The spreadsheet is set up in the exact format necessary to upload it into the system, so it is important that no changes are made to the spreadsheet’s format. Please DO NOT delete any of the optional columns if they will not be used. The following chart provides guidelines to complete the spreadsheet.

Excel Column
Optional/Required
Field Type
Field Size (in characters)
Vendor Customer Code *
Leave Blank
Alpha Numeric
20
Supplier Part Number **
Required
Text
32
Supplier Name
Required
Alpha Numeric
60
Manufacturer Name
Optional
Alpha Numeric
25
Manufacturer Part Number
Optional
Alpha Numeric
25
Commodity Code ***
Required
Alpha Numeric
5
Item Description
Required
Alpha Numeric
60
Extended Description
Required
Alpha Numeric
1500
Unit of Measure ****
Required
Alpha Numeric
4
List Price
Required
Number
14 before and 6 after decimal pt
Deliver Days
Required
Number
10
Product / Category
Optional
Alpha Numeric
25
Model
Optional
Alpha Numeric
25
Drawing
Optional
Alpha Numeric
25
Piece
Optional
Alpha Numeric
25
Serial Number
Optional
Alpha Numeric
25
Specifications
Optional
Alpha Numeric
25
Size
Optional
Alpha Numeric
25
Color
Optional
Alpha Numeric
25
Picture File Name *****
Optional
Alpha Numeric
255

Leave blank. State of Maine Buyer will complete this column

Format as text, even if the Supplier Part Number contains only numbers

See NIGP Codes (5-digit) at: http://www.maine.gov/purchases/vendorinfo/vss.htm

(Note: Use 3-digit Class plus 2-digit Item to equal 5-digit Code.)

Select Units from the attached Unit_of_Measure.xls file Add picture file name only if you have images for the contract

File details come from the government source that posted it. Updated .